home *** CD-ROM | disk | FTP | other *** search
dBase Query | 1993-03-09 | 3.3 KB | 42 lines |
- * dBASE IV .QBE file 8
- CLOSE DATABASES
- SELECT 1
- USE NAMES.DBF
- SET FILTER TO
- QBE___SAFE = SET("SAFETY")
- QBE___CATA = SET("CATALOG")
- SET SAFETY OFF
- SET CATALOG OFF
- GO TOP
- IF RECCOUNT() > 1
- QBE___12 = '.\'+LTRIM(STR(RAND(-1)*100000000,8))
- SORT TO &QBE___12 ON STATE/A,CITY/A
- USE &QBE___12 NOSAVE NOUPDATE
- ENDIF
- SET SAFETY &QBE___SAFE
- SET CATALOG &QBE___CATA
- GO TOP
- NAMES.DBF
- :Names.dbf*$i
- :LASTNAME*$i
- :FIRSTNAME*$i
- :ADDRESS*$i
- :CITY*$i
- :STATE*$i
- :ZIP*$i
- :PHONE*$i
- :BUSINESS*$i
- :Lastname+Firstname*$i
- :TRIM(Lastname)+Firstname*$i
- ,xx:Asc2*$i
- ,xx:Asc1*$i
- ,xx:*$i
- :guests*$i ,
- *$i ,
- *$i ,
- *$i ,
- *$i ,
- *$i ,
- *$i ,
- *$i ,
-